REP-56048 When Generating Large PDF Using Font Subsetting And UTF8 Character Set

Generating a PDF file from a large report, causes engine crash:

REP-56048: Engine rwEng-0 crashed job id xxThe issue occurs in the following environment:

1.Server Platform : Microsoft Windows Server 2003 
2.Oracle Reports 10.1.2.3 
3.PDF font subsetting is used 
4.NLS_LANG=_.UTF8 
Checking the option "Install files for complex script and right-to-left language" in Regional and Language Options > Languages does not help

Trying different values for jvmOptions does not help:

-Xmx512M -Xms128M -Xss512k 
-Xmx1024M -Xms128M -Xss512k 
......

When PDF subsetting is commented out, the issue does not reproduce. 
When using different NLS_LANG rather UTF8, the issue does not reproduce.

Cause
Bug 7133555 - REPORTS SERVER(ENGINE) HANGS WHEN RUNNING PDF REPORT WITH MANY PAGES ON WIN2003

Solution
Download and Apply one-off Patch 7133555 on top of reports 10.1.2.3


Source : Oracle Metalink: Doc ID 888222.1

PDF Report Output Fails with REP-56048 when Using a GIF Image

Running a PDF report that includes a GIF image file in the layout model and using the Oracle Reports parameter "outputimageformat=gif" is causing the report engine to crash and the following error is being displayed:

REP-56048: Engine rwEng-0 crashed., job Id

Cause
GIF Image format file not being recognized or is corrupted. 

Solution
If the original GIF image file is available, then open it with an Image Editor and save it as JPG image format file and then replace the GIF image in the report definition file with the new JPG image format one.

If the original GIF image file is not available, then following steps can be done to retrieve the image from the original report and then save it as JPG image format.

1.Open the report in Reports Builder.
2.Go to Paper Layout where you can see the image.
3.Type on keyboard shift+PrtScn.
4.Open mspaint.exe (Microsoft Paint - Windows Image Editor).
5.Paste the screenshot from step 3 with ctrl+v.
6.Select the image area and do ctrl+c.
7.Open a new mspaint.exe and do ctrl+v and resize image if needed.
8.Save the image as JPG format.
9.Now you can insert the new image in your report to replace the GIF one.


Source : ORacle Metalink Doc ID: 987009.1

PDF Printing slovenian characters problem

PDF Printing slovenian characters problem :

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=11031

As I understand the limitation of reports 6i is due to the fact that Reports 6i has builtin support for an older PDF standard V1.1.

It's a documented limitation, see Metalink Note 222663.1.

"PDF output is only supported for latin 1 code pages (US7ASCII, WE8ISO8859P1 and WE8MSWIN1252). "

Oracle Reports background engine stopping

In Forms 6i when a report is run, a background process called Reports Background Engine is created. Sometimes we want  this process to be terminated automatically when a report is completed and we exit from report.

Here is the PL/SQL code for this:

DECLARE
  pl_id ParamList;
BEGIN
  pl_id := Create_Parameter_List('dummy');
  Add_Parameter(pl_id,'ORACLE_SHUTDOWN',TEXT_PARAMETER,'Yes');
  Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');
  Run_product(REPORTS,'<>',SYNCHRONOUS,     RUNTIME,FILESYSTEM,pl_id,NULL);
END;

Compiling all the Forms and Reports modules residing in a directory

For Windows

Forms/Reports 6i

REM WINDOWS COMPILE FORMS 
::compile_forms.bat 
cls 
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp60 userid=scott/tiger@v817  module=%%f batch=yes 
    module_type=form compile_all=yes window_state=minimize 
ECHO FINISHED COMPILING 

REM WINDOWS COMPILE REPORT 
::compile_report.bat 
cls 
Echo compiling Report .....
for %%f IN (*.rdf) do RWCON60 userid=scott/tiger@v817 batch=yes source=%%f 
    stype=rdffile DTYPE=REPFILE  OVERWRITE=yes  logfile=log.txt
ECHO FINISHED COMPILING
Forms/Reports 9.0.X

REM WINDOWS COMPILE FORMS 
::compile_forms.bat 
cls 
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp90 userid=scott/tiger@v817  module=%%f batch=yes 
    module_type=form compile_all=yes window_state=minimize 
ECHO FINISHED COMPILING 

REM WINDOWS COMPILE REPORT 
::compile_report.bat 
cls 
Echo compiling Report .....
for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes 
    source=%%f stype=rdffile DTYPE=REPFILE  OVERWRITE=yes  logfile=log.txt
ECHO FINISHED COMPILING
For UNIX

Forms/Reports 6i

#UNIX Forms Compile 
#compile_forms.sh 
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f60genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form 
    compile_all=yes window_state=minimize
done

#UNIX COMPILE REPORTS
#compile_rep.sh
for i  in `ls  *.rdf`
do
echo Compiling Report $i  ...
rwcon60 userid=scott/tiger@bs817 batch=yes source=$i  stype=rdffile 
    dtype=repfile overwrite=yes
done
Forms/Reports 9.0.X

#UNIX Forms Compile 
#compile_forms.sh 
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f90genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form 
    compile_all=yes window_state=minimize
done

( For 10g = forms 9.0.4.x, you can use f90gen also)

#UNIX COMPILE REPORTS
#compile_rep.sh
for i  in `ls  *.rdf`
do
echo Compiling Report $i  ...
rwconverter.sh userid=scott/tiger@bs817 batch=yes source=$i  
    stype=rdffile dtype=repfile overwrite=yes
done

How to Hide or Remove a Parameter from the Reports Parameter Form?

When you create a new user parameter, it is added to the parameter form automatically as you have seen.  The way to hide an undesired parameter is to de-select it from the parameter form builder.  Unfortunately, if you had already modified the parameter form, the layout and headers will be defaulted after you de-select the parameter.

Steps to remove the parameter from the form:

1. Open the report in Reports Builder

2. In the Object Navigator, double click on the icon next to Parameter Form

3. Note the layout and headers in this parameter form (there is no way to print this out to save)

4. Click on Tools from the menu

5. Click on Parameter Form Builder

6. Scroll to the bottom where your user parameters are listed

7. Click on the parameter you do not want to see (make it unhighlighted)

8. Click OK

9. This will replace what you already have built

10. Re-adjust parameter form to what you had in step 3